package com.yantong.pojo;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrdersnIsNull() {
            addCriterion("ordersn is null");
            return (Criteria) this;
        }

        public Criteria andOrdersnIsNotNull() {
            addCriterion("ordersn is not null");
            return (Criteria) this;
        }

        public Criteria andOrdersnEqualTo(String value) {
            addCriterion("ordersn =", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnNotEqualTo(String value) {
            addCriterion("ordersn <>", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnGreaterThan(String value) {
            addCriterion("ordersn >", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnGreaterThanOrEqualTo(String value) {
            addCriterion("ordersn >=", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnLessThan(String value) {
            addCriterion("ordersn <", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnLessThanOrEqualTo(String value) {
            addCriterion("ordersn <=", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnLike(String value) {
            addCriterion("ordersn like", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnNotLike(String value) {
            addCriterion("ordersn not like", value, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnIn(List<String> values) {
            addCriterion("ordersn in", values, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnNotIn(List<String> values) {
            addCriterion("ordersn not in", values, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnBetween(String value1, String value2) {
            addCriterion("ordersn between", value1, value2, "ordersn");
            return (Criteria) this;
        }

        public Criteria andOrdersnNotBetween(String value1, String value2) {
            addCriterion("ordersn not between", value1, value2, "ordersn");
            return (Criteria) this;
        }

        public Criteria andMidIsNull() {
            addCriterion("mid is null");
            return (Criteria) this;
        }

        public Criteria andMidIsNotNull() {
            addCriterion("mid is not null");
            return (Criteria) this;
        }

        public Criteria andMidEqualTo(Long value) {
            addCriterion("mid =", value, "mid");
            return (Criteria) this;
        }

        public Criteria andMidNotEqualTo(Long value) {
            addCriterion("mid <>", value, "mid");
            return (Criteria) this;
        }

        public Criteria andMidGreaterThan(Long value) {
            addCriterion("mid >", value, "mid");
            return (Criteria) this;
        }

        public Criteria andMidGreaterThanOrEqualTo(Long value) {
            addCriterion("mid >=", value, "mid");
            return (Criteria) this;
        }

        public Criteria andMidLessThan(Long value) {
            addCriterion("mid <", value, "mid");
            return (Criteria) this;
        }

        public Criteria andMidLessThanOrEqualTo(Long value) {
            addCriterion("mid <=", value, "mid");
            return (Criteria) this;
        }

        public Criteria andMidIn(List<Long> values) {
            addCriterion("mid in", values, "mid");
            return (Criteria) this;
        }

        public Criteria andMidNotIn(List<Long> values) {
            addCriterion("mid not in", values, "mid");
            return (Criteria) this;
        }

        public Criteria andMidBetween(Long value1, Long value2) {
            addCriterion("mid between", value1, value2, "mid");
            return (Criteria) this;
        }

        public Criteria andMidNotBetween(Long value1, Long value2) {
            addCriterion("mid not between", value1, value2, "mid");
            return (Criteria) this;
        }

        public Criteria andOpenidIsNull() {
            addCriterion("openid is null");
            return (Criteria) this;
        }

        public Criteria andOpenidIsNotNull() {
            addCriterion("openid is not null");
            return (Criteria) this;
        }

        public Criteria andOpenidEqualTo(String value) {
            addCriterion("openid =", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotEqualTo(String value) {
            addCriterion("openid <>", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidGreaterThan(String value) {
            addCriterion("openid >", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidGreaterThanOrEqualTo(String value) {
            addCriterion("openid >=", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidLessThan(String value) {
            addCriterion("openid <", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidLessThanOrEqualTo(String value) {
            addCriterion("openid <=", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidLike(String value) {
            addCriterion("openid like", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotLike(String value) {
            addCriterion("openid not like", value, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidIn(List<String> values) {
            addCriterion("openid in", values, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotIn(List<String> values) {
            addCriterion("openid not in", values, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidBetween(String value1, String value2) {
            addCriterion("openid between", value1, value2, "openid");
            return (Criteria) this;
        }

        public Criteria andOpenidNotBetween(String value1, String value2) {
            addCriterion("openid not between", value1, value2, "openid");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNull() {
            addCriterion("nickname is null");
            return (Criteria) this;
        }

        public Criteria andNicknameIsNotNull() {
            addCriterion("nickname is not null");
            return (Criteria) this;
        }

        public Criteria andNicknameEqualTo(String value) {
            addCriterion("nickname =", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotEqualTo(String value) {
            addCriterion("nickname <>", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThan(String value) {
            addCriterion("nickname >", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("nickname >=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThan(String value) {
            addCriterion("nickname <", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLessThanOrEqualTo(String value) {
            addCriterion("nickname <=", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameLike(String value) {
            addCriterion("nickname like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotLike(String value) {
            addCriterion("nickname not like", value, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameIn(List<String> values) {
            addCriterion("nickname in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotIn(List<String> values) {
            addCriterion("nickname not in", values, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameBetween(String value1, String value2) {
            addCriterion("nickname between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andNicknameNotBetween(String value1, String value2) {
            addCriterion("nickname not between", value1, value2, "nickname");
            return (Criteria) this;
        }

        public Criteria andAvatarIsNull() {
            addCriterion("avatar is null");
            return (Criteria) this;
        }

        public Criteria andAvatarIsNotNull() {
            addCriterion("avatar is not null");
            return (Criteria) this;
        }

        public Criteria andAvatarEqualTo(String value) {
            addCriterion("avatar =", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotEqualTo(String value) {
            addCriterion("avatar <>", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarGreaterThan(String value) {
            addCriterion("avatar >", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarGreaterThanOrEqualTo(String value) {
            addCriterion("avatar >=", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarLessThan(String value) {
            addCriterion("avatar <", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarLessThanOrEqualTo(String value) {
            addCriterion("avatar <=", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarLike(String value) {
            addCriterion("avatar like", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotLike(String value) {
            addCriterion("avatar not like", value, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarIn(List<String> values) {
            addCriterion("avatar in", values, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotIn(List<String> values) {
            addCriterion("avatar not in", values, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarBetween(String value1, String value2) {
            addCriterion("avatar between", value1, value2, "avatar");
            return (Criteria) this;
        }

        public Criteria andAvatarNotBetween(String value1, String value2) {
            addCriterion("avatar not between", value1, value2, "avatar");
            return (Criteria) this;
        }

        public Criteria andRealnameIsNull() {
            addCriterion("realname is null");
            return (Criteria) this;
        }

        public Criteria andRealnameIsNotNull() {
            addCriterion("realname is not null");
            return (Criteria) this;
        }

        public Criteria andRealnameEqualTo(String value) {
            addCriterion("realname =", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotEqualTo(String value) {
            addCriterion("realname <>", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameGreaterThan(String value) {
            addCriterion("realname >", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameGreaterThanOrEqualTo(String value) {
            addCriterion("realname >=", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameLessThan(String value) {
            addCriterion("realname <", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameLessThanOrEqualTo(String value) {
            addCriterion("realname <=", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameLike(String value) {
            addCriterion("realname like", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotLike(String value) {
            addCriterion("realname not like", value, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameIn(List<String> values) {
            addCriterion("realname in", values, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotIn(List<String> values) {
            addCriterion("realname not in", values, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameBetween(String value1, String value2) {
            addCriterion("realname between", value1, value2, "realname");
            return (Criteria) this;
        }

        public Criteria andRealnameNotBetween(String value1, String value2) {
            addCriterion("realname not between", value1, value2, "realname");
            return (Criteria) this;
        }

        public Criteria andOrderpriceIsNull() {
            addCriterion("orderprice is null");
            return (Criteria) this;
        }

        public Criteria andOrderpriceIsNotNull() {
            addCriterion("orderprice is not null");
            return (Criteria) this;
        }

        public Criteria andOrderpriceEqualTo(BigDecimal value) {
            addCriterion("orderprice =", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceNotEqualTo(BigDecimal value) {
            addCriterion("orderprice <>", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceGreaterThan(BigDecimal value) {
            addCriterion("orderprice >", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("orderprice >=", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceLessThan(BigDecimal value) {
            addCriterion("orderprice <", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("orderprice <=", value, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceIn(List<BigDecimal> values) {
            addCriterion("orderprice in", values, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceNotIn(List<BigDecimal> values) {
            addCriterion("orderprice not in", values, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("orderprice between", value1, value2, "orderprice");
            return (Criteria) this;
        }

        public Criteria andOrderpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("orderprice not between", value1, value2, "orderprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceIsNull() {
            addCriterion("payprice is null");
            return (Criteria) this;
        }

        public Criteria andPaypriceIsNotNull() {
            addCriterion("payprice is not null");
            return (Criteria) this;
        }

        public Criteria andPaypriceEqualTo(BigDecimal value) {
            addCriterion("payprice =", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceNotEqualTo(BigDecimal value) {
            addCriterion("payprice <>", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceGreaterThan(BigDecimal value) {
            addCriterion("payprice >", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("payprice >=", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceLessThan(BigDecimal value) {
            addCriterion("payprice <", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("payprice <=", value, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceIn(List<BigDecimal> values) {
            addCriterion("payprice in", values, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceNotIn(List<BigDecimal> values) {
            addCriterion("payprice not in", values, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payprice between", value1, value2, "payprice");
            return (Criteria) this;
        }

        public Criteria andPaypriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payprice not between", value1, value2, "payprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceIsNull() {
            addCriterion("goodsprice is null");
            return (Criteria) this;
        }

        public Criteria andGoodspriceIsNotNull() {
            addCriterion("goodsprice is not null");
            return (Criteria) this;
        }

        public Criteria andGoodspriceEqualTo(BigDecimal value) {
            addCriterion("goodsprice =", value, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceNotEqualTo(BigDecimal value) {
            addCriterion("goodsprice <>", value, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceGreaterThan(BigDecimal value) {
            addCriterion("goodsprice >", value, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goodsprice >=", value, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceLessThan(BigDecimal value) {
            addCriterion("goodsprice <", value, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goodsprice <=", value, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceIn(List<BigDecimal> values) {
            addCriterion("goodsprice in", values, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceNotIn(List<BigDecimal> values) {
            addCriterion("goodsprice not in", values, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goodsprice between", value1, value2, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andGoodspriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goodsprice not between", value1, value2, "goodsprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceIsNull() {
            addCriterion("discountprice is null");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceIsNotNull() {
            addCriterion("discountprice is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceEqualTo(BigDecimal value) {
            addCriterion("discountprice =", value, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceNotEqualTo(BigDecimal value) {
            addCriterion("discountprice <>", value, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceGreaterThan(BigDecimal value) {
            addCriterion("discountprice >", value, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discountprice >=", value, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceLessThan(BigDecimal value) {
            addCriterion("discountprice <", value, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discountprice <=", value, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceIn(List<BigDecimal> values) {
            addCriterion("discountprice in", values, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceNotIn(List<BigDecimal> values) {
            addCriterion("discountprice not in", values, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountprice between", value1, value2, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDiscountpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discountprice not between", value1, value2, "discountprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceIsNull() {
            addCriterion("deductprice is null");
            return (Criteria) this;
        }

        public Criteria andDeductpriceIsNotNull() {
            addCriterion("deductprice is not null");
            return (Criteria) this;
        }

        public Criteria andDeductpriceEqualTo(BigDecimal value) {
            addCriterion("deductprice =", value, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceNotEqualTo(BigDecimal value) {
            addCriterion("deductprice <>", value, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceGreaterThan(BigDecimal value) {
            addCriterion("deductprice >", value, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("deductprice >=", value, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceLessThan(BigDecimal value) {
            addCriterion("deductprice <", value, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("deductprice <=", value, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceIn(List<BigDecimal> values) {
            addCriterion("deductprice in", values, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceNotIn(List<BigDecimal> values) {
            addCriterion("deductprice not in", values, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deductprice between", value1, value2, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductpriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deductprice not between", value1, value2, "deductprice");
            return (Criteria) this;
        }

        public Criteria andDeductcreditIsNull() {
            addCriterion("deductcredit is null");
            return (Criteria) this;
        }

        public Criteria andDeductcreditIsNotNull() {
            addCriterion("deductcredit is not null");
            return (Criteria) this;
        }

        public Criteria andDeductcreditEqualTo(Integer value) {
            addCriterion("deductcredit =", value, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditNotEqualTo(Integer value) {
            addCriterion("deductcredit <>", value, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditGreaterThan(Integer value) {
            addCriterion("deductcredit >", value, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditGreaterThanOrEqualTo(Integer value) {
            addCriterion("deductcredit >=", value, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditLessThan(Integer value) {
            addCriterion("deductcredit <", value, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditLessThanOrEqualTo(Integer value) {
            addCriterion("deductcredit <=", value, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditIn(List<Integer> values) {
            addCriterion("deductcredit in", values, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditNotIn(List<Integer> values) {
            addCriterion("deductcredit not in", values, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditBetween(Integer value1, Integer value2) {
            addCriterion("deductcredit between", value1, value2, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcreditNotBetween(Integer value1, Integer value2) {
            addCriterion("deductcredit not between", value1, value2, "deductcredit");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2IsNull() {
            addCriterion("deductcredit2 is null");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2IsNotNull() {
            addCriterion("deductcredit2 is not null");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2EqualTo(BigDecimal value) {
            addCriterion("deductcredit2 =", value, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2NotEqualTo(BigDecimal value) {
            addCriterion("deductcredit2 <>", value, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2GreaterThan(BigDecimal value) {
            addCriterion("deductcredit2 >", value, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2GreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("deductcredit2 >=", value, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2LessThan(BigDecimal value) {
            addCriterion("deductcredit2 <", value, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2LessThanOrEqualTo(BigDecimal value) {
            addCriterion("deductcredit2 <=", value, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2In(List<BigDecimal> values) {
            addCriterion("deductcredit2 in", values, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2NotIn(List<BigDecimal> values) {
            addCriterion("deductcredit2 not in", values, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2Between(BigDecimal value1, BigDecimal value2) {
            addCriterion("deductcredit2 between", value1, value2, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andDeductcredit2NotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("deductcredit2 not between", value1, value2, "deductcredit2");
            return (Criteria) this;
        }

        public Criteria andStatusIsNull() {
            addCriterion("status is null");
            return (Criteria) this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion("status is not null");
            return (Criteria) this;
        }

        public Criteria andStatusEqualTo(Integer value) {
            addCriterion("status =", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotEqualTo(Integer value) {
            addCriterion("status <>", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThan(Integer value) {
            addCriterion("status >", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("status >=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThan(Integer value) {
            addCriterion("status <", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusLessThanOrEqualTo(Integer value) {
            addCriterion("status <=", value, "status");
            return (Criteria) this;
        }

        public Criteria andStatusIn(List<Integer> values) {
            addCriterion("status in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotIn(List<Integer> values) {
            addCriterion("status not in", values, "status");
            return (Criteria) this;
        }

        public Criteria andStatusBetween(Integer value1, Integer value2) {
            addCriterion("status between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("status not between", value1, value2, "status");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("create_time is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("create_time is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("create_time =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("create_time <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("create_time >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("create_time >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("create_time <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("create_time <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("create_time in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("create_time not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("create_time between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("create_time not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNull() {
            addCriterion("paystatus is null");
            return (Criteria) this;
        }

        public Criteria andPaystatusIsNotNull() {
            addCriterion("paystatus is not null");
            return (Criteria) this;
        }

        public Criteria andPaystatusEqualTo(Integer value) {
            addCriterion("paystatus =", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotEqualTo(Integer value) {
            addCriterion("paystatus <>", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThan(Integer value) {
            addCriterion("paystatus >", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("paystatus >=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThan(Integer value) {
            addCriterion("paystatus <", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusLessThanOrEqualTo(Integer value) {
            addCriterion("paystatus <=", value, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusIn(List<Integer> values) {
            addCriterion("paystatus in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotIn(List<Integer> values) {
            addCriterion("paystatus not in", values, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusBetween(Integer value1, Integer value2) {
            addCriterion("paystatus between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaystatusNotBetween(Integer value1, Integer value2) {
            addCriterion("paystatus not between", value1, value2, "paystatus");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNull() {
            addCriterion("paytype is null");
            return (Criteria) this;
        }

        public Criteria andPaytypeIsNotNull() {
            addCriterion("paytype is not null");
            return (Criteria) this;
        }

        public Criteria andPaytypeEqualTo(Integer value) {
            addCriterion("paytype =", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotEqualTo(Integer value) {
            addCriterion("paytype <>", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThan(Integer value) {
            addCriterion("paytype >", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("paytype >=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThan(Integer value) {
            addCriterion("paytype <", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeLessThanOrEqualTo(Integer value) {
            addCriterion("paytype <=", value, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeIn(List<Integer> values) {
            addCriterion("paytype in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotIn(List<Integer> values) {
            addCriterion("paytype not in", values, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeBetween(Integer value1, Integer value2) {
            addCriterion("paytype between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPaytypeNotBetween(Integer value1, Integer value2) {
            addCriterion("paytype not between", value1, value2, "paytype");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPaynoIsNull() {
            addCriterion("payno is null");
            return (Criteria) this;
        }

        public Criteria andPaynoIsNotNull() {
            addCriterion("payno is not null");
            return (Criteria) this;
        }

        public Criteria andPaynoEqualTo(String value) {
            addCriterion("payno =", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoNotEqualTo(String value) {
            addCriterion("payno <>", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoGreaterThan(String value) {
            addCriterion("payno >", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoGreaterThanOrEqualTo(String value) {
            addCriterion("payno >=", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoLessThan(String value) {
            addCriterion("payno <", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoLessThanOrEqualTo(String value) {
            addCriterion("payno <=", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoLike(String value) {
            addCriterion("payno like", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoNotLike(String value) {
            addCriterion("payno not like", value, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoIn(List<String> values) {
            addCriterion("payno in", values, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoNotIn(List<String> values) {
            addCriterion("payno not in", values, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoBetween(String value1, String value2) {
            addCriterion("payno between", value1, value2, "payno");
            return (Criteria) this;
        }

        public Criteria andPaynoNotBetween(String value1, String value2) {
            addCriterion("payno not between", value1, value2, "payno");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoIsNull() {
            addCriterion("pay_merchant_no is null");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoIsNotNull() {
            addCriterion("pay_merchant_no is not null");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoEqualTo(String value) {
            addCriterion("pay_merchant_no =", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoNotEqualTo(String value) {
            addCriterion("pay_merchant_no <>", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoGreaterThan(String value) {
            addCriterion("pay_merchant_no >", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoGreaterThanOrEqualTo(String value) {
            addCriterion("pay_merchant_no >=", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoLessThan(String value) {
            addCriterion("pay_merchant_no <", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoLessThanOrEqualTo(String value) {
            addCriterion("pay_merchant_no <=", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoLike(String value) {
            addCriterion("pay_merchant_no like", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoNotLike(String value) {
            addCriterion("pay_merchant_no not like", value, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoIn(List<String> values) {
            addCriterion("pay_merchant_no in", values, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoNotIn(List<String> values) {
            addCriterion("pay_merchant_no not in", values, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoBetween(String value1, String value2) {
            addCriterion("pay_merchant_no between", value1, value2, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayMerchantNoNotBetween(String value1, String value2) {
            addCriterion("pay_merchant_no not between", value1, value2, "payMerchantNo");
            return (Criteria) this;
        }

        public Criteria andPayopenidIsNull() {
            addCriterion("payopenid is null");
            return (Criteria) this;
        }

        public Criteria andPayopenidIsNotNull() {
            addCriterion("payopenid is not null");
            return (Criteria) this;
        }

        public Criteria andPayopenidEqualTo(String value) {
            addCriterion("payopenid =", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidNotEqualTo(String value) {
            addCriterion("payopenid <>", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidGreaterThan(String value) {
            addCriterion("payopenid >", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidGreaterThanOrEqualTo(String value) {
            addCriterion("payopenid >=", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidLessThan(String value) {
            addCriterion("payopenid <", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidLessThanOrEqualTo(String value) {
            addCriterion("payopenid <=", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidLike(String value) {
            addCriterion("payopenid like", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidNotLike(String value) {
            addCriterion("payopenid not like", value, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidIn(List<String> values) {
            addCriterion("payopenid in", values, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidNotIn(List<String> values) {
            addCriterion("payopenid not in", values, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidBetween(String value1, String value2) {
            addCriterion("payopenid between", value1, value2, "payopenid");
            return (Criteria) this;
        }

        public Criteria andPayopenidNotBetween(String value1, String value2) {
            addCriterion("payopenid not between", value1, value2, "payopenid");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoIsNull() {
            addCriterion("out_trade_no is null");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoIsNotNull() {
            addCriterion("out_trade_no is not null");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoEqualTo(String value) {
            addCriterion("out_trade_no =", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoNotEqualTo(String value) {
            addCriterion("out_trade_no <>", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoGreaterThan(String value) {
            addCriterion("out_trade_no >", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoGreaterThanOrEqualTo(String value) {
            addCriterion("out_trade_no >=", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoLessThan(String value) {
            addCriterion("out_trade_no <", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoLessThanOrEqualTo(String value) {
            addCriterion("out_trade_no <=", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoLike(String value) {
            addCriterion("out_trade_no like", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoNotLike(String value) {
            addCriterion("out_trade_no not like", value, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoIn(List<String> values) {
            addCriterion("out_trade_no in", values, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoNotIn(List<String> values) {
            addCriterion("out_trade_no not in", values, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoBetween(String value1, String value2) {
            addCriterion("out_trade_no between", value1, value2, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andOutTradeNoNotBetween(String value1, String value2) {
            addCriterion("out_trade_no not between", value1, value2, "outTradeNo");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("remark is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("remark is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("remark =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("remark <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("remark >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("remark >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("remark <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("remark <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("remark like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("remark not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("remark in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("remark not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("remark between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("remark not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andSnameIsNull() {
            addCriterion("sname is null");
            return (Criteria) this;
        }

        public Criteria andSnameIsNotNull() {
            addCriterion("sname is not null");
            return (Criteria) this;
        }

        public Criteria andSnameEqualTo(String value) {
            addCriterion("sname =", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameNotEqualTo(String value) {
            addCriterion("sname <>", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameGreaterThan(String value) {
            addCriterion("sname >", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameGreaterThanOrEqualTo(String value) {
            addCriterion("sname >=", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameLessThan(String value) {
            addCriterion("sname <", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameLessThanOrEqualTo(String value) {
            addCriterion("sname <=", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameLike(String value) {
            addCriterion("sname like", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameNotLike(String value) {
            addCriterion("sname not like", value, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameIn(List<String> values) {
            addCriterion("sname in", values, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameNotIn(List<String> values) {
            addCriterion("sname not in", values, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameBetween(String value1, String value2) {
            addCriterion("sname between", value1, value2, "sname");
            return (Criteria) this;
        }

        public Criteria andSnameNotBetween(String value1, String value2) {
            addCriterion("sname not between", value1, value2, "sname");
            return (Criteria) this;
        }

        public Criteria andMobileIsNull() {
            addCriterion("mobile is null");
            return (Criteria) this;
        }

        public Criteria andMobileIsNotNull() {
            addCriterion("mobile is not null");
            return (Criteria) this;
        }

        public Criteria andMobileEqualTo(String value) {
            addCriterion("mobile =", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotEqualTo(String value) {
            addCriterion("mobile <>", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThan(String value) {
            addCriterion("mobile >", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileGreaterThanOrEqualTo(String value) {
            addCriterion("mobile >=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThan(String value) {
            addCriterion("mobile <", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLessThanOrEqualTo(String value) {
            addCriterion("mobile <=", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileLike(String value) {
            addCriterion("mobile like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotLike(String value) {
            addCriterion("mobile not like", value, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileIn(List<String> values) {
            addCriterion("mobile in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotIn(List<String> values) {
            addCriterion("mobile not in", values, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileBetween(String value1, String value2) {
            addCriterion("mobile between", value1, value2, "mobile");
            return (Criteria) this;
        }

        public Criteria andMobileNotBetween(String value1, String value2) {
            addCriterion("mobile not between", value1, value2, "mobile");
            return (Criteria) this;
        }


        public Criteria andProvinceIsNull() {
            addCriterion("province is null");
            return (Criteria) this;
        }

        public Criteria andProvinceIsNotNull() {
            addCriterion("province is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceEqualTo(String value) {
            addCriterion("province =", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotEqualTo(String value) {
            addCriterion("province <>", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThan(String value) {
            addCriterion("province >", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceGreaterThanOrEqualTo(String value) {
            addCriterion("province >=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThan(String value) {
            addCriterion("province <", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLessThanOrEqualTo(String value) {
            addCriterion("province <=", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceLike(String value) {
            addCriterion("province like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotLike(String value) {
            addCriterion("province not like", value, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceIn(List<String> values) {
            addCriterion("province in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotIn(List<String> values) {
            addCriterion("province not in", values, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceBetween(String value1, String value2) {
            addCriterion("province between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andProvinceNotBetween(String value1, String value2) {
            addCriterion("province not between", value1, value2, "province");
            return (Criteria) this;
        }

        public Criteria andCityIsNull() {
            addCriterion("city is null");
            return (Criteria) this;
        }

        public Criteria andCityIsNotNull() {
            addCriterion("city is not null");
            return (Criteria) this;
        }

        public Criteria andCityEqualTo(String value) {
            addCriterion("city =", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotEqualTo(String value) {
            addCriterion("city <>", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThan(String value) {
            addCriterion("city >", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityGreaterThanOrEqualTo(String value) {
            addCriterion("city >=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThan(String value) {
            addCriterion("city <", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLessThanOrEqualTo(String value) {
            addCriterion("city <=", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityLike(String value) {
            addCriterion("city like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotLike(String value) {
            addCriterion("city not like", value, "city");
            return (Criteria) this;
        }

        public Criteria andCityIn(List<String> values) {
            addCriterion("city in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotIn(List<String> values) {
            addCriterion("city not in", values, "city");
            return (Criteria) this;
        }

        public Criteria andCityBetween(String value1, String value2) {
            addCriterion("city between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andCityNotBetween(String value1, String value2) {
            addCriterion("city not between", value1, value2, "city");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNull() {
            addCriterion("district is null");
            return (Criteria) this;
        }

        public Criteria andDistrictIsNotNull() {
            addCriterion("district is not null");
            return (Criteria) this;
        }

        public Criteria andDistrictEqualTo(String value) {
            addCriterion("district =", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotEqualTo(String value) {
            addCriterion("district <>", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThan(String value) {
            addCriterion("district >", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictGreaterThanOrEqualTo(String value) {
            addCriterion("district >=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThan(String value) {
            addCriterion("district <", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLessThanOrEqualTo(String value) {
            addCriterion("district <=", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictLike(String value) {
            addCriterion("district like", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotLike(String value) {
            addCriterion("district not like", value, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictIn(List<String> values) {
            addCriterion("district in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotIn(List<String> values) {
            addCriterion("district not in", values, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictBetween(String value1, String value2) {
            addCriterion("district between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andDistrictNotBetween(String value1, String value2) {
            addCriterion("district not between", value1, value2, "district");
            return (Criteria) this;
        }

        public Criteria andAddressIsNull() {
            addCriterion("address is null");
            return (Criteria) this;
        }

        public Criteria andAddressIsNotNull() {
            addCriterion("address is not null");
            return (Criteria) this;
        }

        public Criteria andAddressEqualTo(String value) {
            addCriterion("address =", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotEqualTo(String value) {
            addCriterion("address <>", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThan(String value) {
            addCriterion("address >", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressGreaterThanOrEqualTo(String value) {
            addCriterion("address >=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThan(String value) {
            addCriterion("address <", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLessThanOrEqualTo(String value) {
            addCriterion("address <=", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressLike(String value) {
            addCriterion("address like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotLike(String value) {
            addCriterion("address not like", value, "address");
            return (Criteria) this;
        }

        public Criteria andAddressIn(List<String> values) {
            addCriterion("address in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotIn(List<String> values) {
            addCriterion("address not in", values, "address");
            return (Criteria) this;
        }

        public Criteria andAddressBetween(String value1, String value2) {
            addCriterion("address between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andAddressNotBetween(String value1, String value2) {
            addCriterion("address not between", value1, value2, "address");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Integer value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Integer value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Integer value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Integer value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Integer value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Integer> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Integer> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Integer value1, Integer value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedIsNull() {
            addCriterion("sysdeleted is null");
            return (Criteria) this;
        }

        public Criteria andSysdeletedIsNotNull() {
            addCriterion("sysdeleted is not null");
            return (Criteria) this;
        }

        public Criteria andSysdeletedEqualTo(Integer value) {
            addCriterion("sysdeleted =", value, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedNotEqualTo(Integer value) {
            addCriterion("sysdeleted <>", value, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedGreaterThan(Integer value) {
            addCriterion("sysdeleted >", value, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("sysdeleted >=", value, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedLessThan(Integer value) {
            addCriterion("sysdeleted <", value, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedLessThanOrEqualTo(Integer value) {
            addCriterion("sysdeleted <=", value, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedIn(List<Integer> values) {
            addCriterion("sysdeleted in", values, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedNotIn(List<Integer> values) {
            addCriterion("sysdeleted not in", values, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedBetween(Integer value1, Integer value2) {
            addCriterion("sysdeleted between", value1, value2, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andSysdeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("sysdeleted not between", value1, value2, "sysdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedIsNull() {
            addCriterion("userdeleted is null");
            return (Criteria) this;
        }

        public Criteria andUserdeletedIsNotNull() {
            addCriterion("userdeleted is not null");
            return (Criteria) this;
        }

        public Criteria andUserdeletedEqualTo(Integer value) {
            addCriterion("userdeleted =", value, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedNotEqualTo(Integer value) {
            addCriterion("userdeleted <>", value, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedGreaterThan(Integer value) {
            addCriterion("userdeleted >", value, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedGreaterThanOrEqualTo(Integer value) {
            addCriterion("userdeleted >=", value, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedLessThan(Integer value) {
            addCriterion("userdeleted <", value, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedLessThanOrEqualTo(Integer value) {
            addCriterion("userdeleted <=", value, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedIn(List<Integer> values) {
            addCriterion("userdeleted in", values, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedNotIn(List<Integer> values) {
            addCriterion("userdeleted not in", values, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedBetween(Integer value1, Integer value2) {
            addCriterion("userdeleted between", value1, value2, "userdeleted");
            return (Criteria) this;
        }

        public Criteria andUserdeletedNotBetween(Integer value1, Integer value2) {
            addCriterion("userdeleted not between", value1, value2, "userdeleted");
            return (Criteria) this;
        }


        public Criteria andSendTimeIsNull() {
            addCriterion("send_time is null");
            return (Criteria) this;
        }

        public Criteria andSendTimeIsNotNull() {
            addCriterion("send_time is not null");
            return (Criteria) this;
        }

        public Criteria andSendTimeEqualTo(Date value) {
            addCriterion("send_time =", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeNotEqualTo(Date value) {
            addCriterion("send_time <>", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeGreaterThan(Date value) {
            addCriterion("send_time >", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("send_time >=", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeLessThan(Date value) {
            addCriterion("send_time <", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeLessThanOrEqualTo(Date value) {
            addCriterion("send_time <=", value, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeIn(List<Date> values) {
            addCriterion("send_time in", values, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeNotIn(List<Date> values) {
            addCriterion("send_time not in", values, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeBetween(Date value1, Date value2) {
            addCriterion("send_time between", value1, value2, "sendTime");
            return (Criteria) this;
        }

        public Criteria andSendTimeNotBetween(Date value1, Date value2) {
            addCriterion("send_time not between", value1, value2, "sendTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeIsNull() {
            addCriterion("fetch_time is null");
            return (Criteria) this;
        }

        public Criteria andFetchTimeIsNotNull() {
            addCriterion("fetch_time is not null");
            return (Criteria) this;
        }

        public Criteria andFetchTimeEqualTo(Date value) {
            addCriterion("fetch_time =", value, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeNotEqualTo(Date value) {
            addCriterion("fetch_time <>", value, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeGreaterThan(Date value) {
            addCriterion("fetch_time >", value, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("fetch_time >=", value, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeLessThan(Date value) {
            addCriterion("fetch_time <", value, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeLessThanOrEqualTo(Date value) {
            addCriterion("fetch_time <=", value, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeIn(List<Date> values) {
            addCriterion("fetch_time in", values, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeNotIn(List<Date> values) {
            addCriterion("fetch_time not in", values, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeBetween(Date value1, Date value2) {
            addCriterion("fetch_time between", value1, value2, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFetchTimeNotBetween(Date value1, Date value2) {
            addCriterion("fetch_time not between", value1, value2, "fetchTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("finish_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("finish_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(Date value) {
            addCriterion("finish_time =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(Date value) {
            addCriterion("finish_time <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(Date value) {
            addCriterion("finish_time >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finish_time >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(Date value) {
            addCriterion("finish_time <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(Date value) {
            addCriterion("finish_time <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<Date> values) {
            addCriterion("finish_time in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<Date> values) {
            addCriterion("finish_time not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(Date value1, Date value2) {
            addCriterion("finish_time between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(Date value1, Date value2) {
            addCriterion("finish_time not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNull() {
            addCriterion("cancel_time is null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNotNull() {
            addCriterion("cancel_time is not null");
            return (Criteria) this;
        }


        public Criteria andCancelPaytimeIsNull() {
            addCriterion("cancel_paytime is null");
            return (Criteria) this;
        }

        public Criteria andCancelPaytimeIsNotNull() {
            addCriterion("cancel_paytime is not null");
            return (Criteria) this;
        }


        public Criteria andIscommentIsNull() {
            addCriterion("iscomment is null");
            return (Criteria) this;
        }

        public Criteria andIscommentIsNotNull() {
            addCriterion("iscomment is not null");
            return (Criteria) this;
        }

        public Criteria andIscommentEqualTo(Integer value) {
            addCriterion("iscomment =", value, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentNotEqualTo(Integer value) {
            addCriterion("iscomment <>", value, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentGreaterThan(Integer value) {
            addCriterion("iscomment >", value, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentGreaterThanOrEqualTo(Integer value) {
            addCriterion("iscomment >=", value, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentLessThan(Integer value) {
            addCriterion("iscomment <", value, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentLessThanOrEqualTo(Integer value) {
            addCriterion("iscomment <=", value, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentIn(List<Integer> values) {
            addCriterion("iscomment in", values, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentNotIn(List<Integer> values) {
            addCriterion("iscomment not in", values, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentBetween(Integer value1, Integer value2) {
            addCriterion("iscomment between", value1, value2, "iscomment");
            return (Criteria) this;
        }

        public Criteria andIscommentNotBetween(Integer value1, Integer value2) {
            addCriterion("iscomment not between", value1, value2, "iscomment");
            return (Criteria) this;
        }

        public Criteria andRefundidIsNull() {
            addCriterion("refundid is null");
            return (Criteria) this;
        }

        public Criteria andRefundidIsNotNull() {
            addCriterion("refundid is not null");
            return (Criteria) this;
        }

        public Criteria andRefundidEqualTo(Integer value) {
            addCriterion("refundid =", value, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidNotEqualTo(Integer value) {
            addCriterion("refundid <>", value, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidGreaterThan(Integer value) {
            addCriterion("refundid >", value, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidGreaterThanOrEqualTo(Integer value) {
            addCriterion("refundid >=", value, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidLessThan(Integer value) {
            addCriterion("refundid <", value, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidLessThanOrEqualTo(Integer value) {
            addCriterion("refundid <=", value, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidIn(List<Integer> values) {
            addCriterion("refundid in", values, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidNotIn(List<Integer> values) {
            addCriterion("refundid not in", values, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidBetween(Integer value1, Integer value2) {
            addCriterion("refundid between", value1, value2, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundidNotBetween(Integer value1, Integer value2) {
            addCriterion("refundid not between", value1, value2, "refundid");
            return (Criteria) this;
        }

        public Criteria andRefundTimeIsNull() {
            addCriterion("refund_time is null");
            return (Criteria) this;
        }

        public Criteria andRefundTimeIsNotNull() {
            addCriterion("refund_time is not null");
            return (Criteria) this;
        }

        public Criteria andRefundTimeEqualTo(Date value) {
            addCriterion("refund_time =", value, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeNotEqualTo(Date value) {
            addCriterion("refund_time <>", value, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeGreaterThan(Date value) {
            addCriterion("refund_time >", value, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("refund_time >=", value, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeLessThan(Date value) {
            addCriterion("refund_time <", value, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeLessThanOrEqualTo(Date value) {
            addCriterion("refund_time <=", value, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeIn(List<Date> values) {
            addCriterion("refund_time in", values, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeNotIn(List<Date> values) {
            addCriterion("refund_time not in", values, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeBetween(Date value1, Date value2) {
            addCriterion("refund_time between", value1, value2, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundTimeNotBetween(Date value1, Date value2) {
            addCriterion("refund_time not between", value1, value2, "refundTime");
            return (Criteria) this;
        }

        public Criteria andRefundsnIsNull() {
            addCriterion("refundsn is null");
            return (Criteria) this;
        }

        public Criteria andRefundsnIsNotNull() {
            addCriterion("refundsn is not null");
            return (Criteria) this;
        }

        public Criteria andRefundsnEqualTo(String value) {
            addCriterion("refundsn =", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnNotEqualTo(String value) {
            addCriterion("refundsn <>", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnGreaterThan(String value) {
            addCriterion("refundsn >", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnGreaterThanOrEqualTo(String value) {
            addCriterion("refundsn >=", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnLessThan(String value) {
            addCriterion("refundsn <", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnLessThanOrEqualTo(String value) {
            addCriterion("refundsn <=", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnLike(String value) {
            addCriterion("refundsn like", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnNotLike(String value) {
            addCriterion("refundsn not like", value, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnIn(List<String> values) {
            addCriterion("refundsn in", values, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnNotIn(List<String> values) {
            addCriterion("refundsn not in", values, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnBetween(String value1, String value2) {
            addCriterion("refundsn between", value1, value2, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundsnNotBetween(String value1, String value2) {
            addCriterion("refundsn not between", value1, value2, "refundsn");
            return (Criteria) this;
        }

        public Criteria andRefundNoIsNull() {
            addCriterion("refund_no is null");
            return (Criteria) this;
        }

        public Criteria andRefundNoIsNotNull() {
            addCriterion("refund_no is not null");
            return (Criteria) this;
        }

        public Criteria andRefundNoEqualTo(String value) {
            addCriterion("refund_no =", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoNotEqualTo(String value) {
            addCriterion("refund_no <>", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoGreaterThan(String value) {
            addCriterion("refund_no >", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoGreaterThanOrEqualTo(String value) {
            addCriterion("refund_no >=", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoLessThan(String value) {
            addCriterion("refund_no <", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoLessThanOrEqualTo(String value) {
            addCriterion("refund_no <=", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoLike(String value) {
            addCriterion("refund_no like", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoNotLike(String value) {
            addCriterion("refund_no not like", value, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoIn(List<String> values) {
            addCriterion("refund_no in", values, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoNotIn(List<String> values) {
            addCriterion("refund_no not in", values, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoBetween(String value1, String value2) {
            addCriterion("refund_no between", value1, value2, "refundNo");
            return (Criteria) this;
        }

        public Criteria andRefundNoNotBetween(String value1, String value2) {
            addCriterion("refund_no not between", value1, value2, "refundNo");
            return (Criteria) this;
        }

        public Criteria andAutofinishIsNull() {
            addCriterion("autofinish is null");
            return (Criteria) this;
        }

        public Criteria andAutofinishIsNotNull() {
            addCriterion("autofinish is not null");
            return (Criteria) this;
        }

        public Criteria andAutofinishEqualTo(Integer value) {
            addCriterion("autofinish =", value, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishNotEqualTo(Integer value) {
            addCriterion("autofinish <>", value, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishGreaterThan(Integer value) {
            addCriterion("autofinish >", value, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishGreaterThanOrEqualTo(Integer value) {
            addCriterion("autofinish >=", value, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishLessThan(Integer value) {
            addCriterion("autofinish <", value, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishLessThanOrEqualTo(Integer value) {
            addCriterion("autofinish <=", value, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishIn(List<Integer> values) {
            addCriterion("autofinish in", values, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishNotIn(List<Integer> values) {
            addCriterion("autofinish not in", values, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishBetween(Integer value1, Integer value2) {
            addCriterion("autofinish between", value1, value2, "autofinish");
            return (Criteria) this;
        }

        public Criteria andAutofinishNotBetween(Integer value1, Integer value2) {
            addCriterion("autofinish not between", value1, value2, "autofinish");
            return (Criteria) this;
        }

        public Criteria andCloseTimeIsNull() {
            addCriterion("close_time is null");
            return (Criteria) this;
        }

        public Criteria andCloseTimeIsNotNull() {
            addCriterion("close_time is not null");
            return (Criteria) this;
        }

        public Criteria andCloseTimeEqualTo(Date value) {
            addCriterion("close_time =", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotEqualTo(Date value) {
            addCriterion("close_time <>", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeGreaterThan(Date value) {
            addCriterion("close_time >", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("close_time >=", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeLessThan(Date value) {
            addCriterion("close_time <", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeLessThanOrEqualTo(Date value) {
            addCriterion("close_time <=", value, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeIn(List<Date> values) {
            addCriterion("close_time in", values, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotIn(List<Date> values) {
            addCriterion("close_time not in", values, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeBetween(Date value1, Date value2) {
            addCriterion("close_time between", value1, value2, "closeTime");
            return (Criteria) this;
        }

        public Criteria andCloseTimeNotBetween(Date value1, Date value2) {
            addCriterion("close_time not between", value1, value2, "closeTime");
            return (Criteria) this;
        }


        public Criteria andTMidIsNull() {
            addCriterion("t_mid is null");
            return (Criteria) this;
        }

        public Criteria andTMidIsNotNull() {
            addCriterion("t_mid is not null");
            return (Criteria) this;
        }

        public Criteria andTMidEqualTo(Long value) {
            addCriterion("t_mid =", value, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidNotEqualTo(Long value) {
            addCriterion("t_mid <>", value, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidGreaterThan(Long value) {
            addCriterion("t_mid >", value, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidGreaterThanOrEqualTo(Long value) {
            addCriterion("t_mid >=", value, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidLessThan(Long value) {
            addCriterion("t_mid <", value, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidLessThanOrEqualTo(Long value) {
            addCriterion("t_mid <=", value, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidIn(List<Long> values) {
            addCriterion("t_mid in", values, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidNotIn(List<Long> values) {
            addCriterion("t_mid not in", values, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidBetween(Long value1, Long value2) {
            addCriterion("t_mid between", value1, value2, "tMid");
            return (Criteria) this;
        }

        public Criteria andTMidNotBetween(Long value1, Long value2) {
            addCriterion("t_mid not between", value1, value2, "tMid");
            return (Criteria) this;
        }

        public Criteria andTNicknameIsNull() {
            addCriterion("t_nickname is null");
            return (Criteria) this;
        }

        public Criteria andTNicknameIsNotNull() {
            addCriterion("t_nickname is not null");
            return (Criteria) this;
        }

        public Criteria andTNicknameEqualTo(String value) {
            addCriterion("t_nickname =", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameNotEqualTo(String value) {
            addCriterion("t_nickname <>", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameGreaterThan(String value) {
            addCriterion("t_nickname >", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("t_nickname >=", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameLessThan(String value) {
            addCriterion("t_nickname <", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameLessThanOrEqualTo(String value) {
            addCriterion("t_nickname <=", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameLike(String value) {
            addCriterion("t_nickname like", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameNotLike(String value) {
            addCriterion("t_nickname not like", value, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameIn(List<String> values) {
            addCriterion("t_nickname in", values, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameNotIn(List<String> values) {
            addCriterion("t_nickname not in", values, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameBetween(String value1, String value2) {
            addCriterion("t_nickname between", value1, value2, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTNicknameNotBetween(String value1, String value2) {
            addCriterion("t_nickname not between", value1, value2, "tNickname");
            return (Criteria) this;
        }

        public Criteria andTtMidIsNull() {
            addCriterion("tt_mid is null");
            return (Criteria) this;
        }

        public Criteria andTtMidIsNotNull() {
            addCriterion("tt_mid is not null");
            return (Criteria) this;
        }

        public Criteria andTtMidEqualTo(Long value) {
            addCriterion("tt_mid =", value, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidNotEqualTo(Long value) {
            addCriterion("tt_mid <>", value, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidGreaterThan(Long value) {
            addCriterion("tt_mid >", value, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidGreaterThanOrEqualTo(Long value) {
            addCriterion("tt_mid >=", value, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidLessThan(Long value) {
            addCriterion("tt_mid <", value, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidLessThanOrEqualTo(Long value) {
            addCriterion("tt_mid <=", value, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidIn(List<Long> values) {
            addCriterion("tt_mid in", values, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidNotIn(List<Long> values) {
            addCriterion("tt_mid not in", values, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidBetween(Long value1, Long value2) {
            addCriterion("tt_mid between", value1, value2, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtMidNotBetween(Long value1, Long value2) {
            addCriterion("tt_mid not between", value1, value2, "ttMid");
            return (Criteria) this;
        }

        public Criteria andTtNicknameIsNull() {
            addCriterion("tt_nickname is null");
            return (Criteria) this;
        }

        public Criteria andTtNicknameIsNotNull() {
            addCriterion("tt_nickname is not null");
            return (Criteria) this;
        }

        public Criteria andTtNicknameEqualTo(String value) {
            addCriterion("tt_nickname =", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameNotEqualTo(String value) {
            addCriterion("tt_nickname <>", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameGreaterThan(String value) {
            addCriterion("tt_nickname >", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameGreaterThanOrEqualTo(String value) {
            addCriterion("tt_nickname >=", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameLessThan(String value) {
            addCriterion("tt_nickname <", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameLessThanOrEqualTo(String value) {
            addCriterion("tt_nickname <=", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameLike(String value) {
            addCriterion("tt_nickname like", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameNotLike(String value) {
            addCriterion("tt_nickname not like", value, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameIn(List<String> values) {
            addCriterion("tt_nickname in", values, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameNotIn(List<String> values) {
            addCriterion("tt_nickname not in", values, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameBetween(String value1, String value2) {
            addCriterion("tt_nickname between", value1, value2, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andTtNicknameNotBetween(String value1, String value2) {
            addCriterion("tt_nickname not between", value1, value2, "ttNickname");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionIsNull() {
            addCriterion("headcommission is null");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionIsNotNull() {
            addCriterion("headcommission is not null");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionEqualTo(BigDecimal value) {
            addCriterion("headcommission =", value, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionNotEqualTo(BigDecimal value) {
            addCriterion("headcommission <>", value, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionGreaterThan(BigDecimal value) {
            addCriterion("headcommission >", value, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("headcommission >=", value, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionLessThan(BigDecimal value) {
            addCriterion("headcommission <", value, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionLessThanOrEqualTo(BigDecimal value) {
            addCriterion("headcommission <=", value, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionIn(List<BigDecimal> values) {
            addCriterion("headcommission in", values, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionNotIn(List<BigDecimal> values) {
            addCriterion("headcommission not in", values, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("headcommission between", value1, value2, "headcommission");
            return (Criteria) this;
        }

        public Criteria andHeadcommissionNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("headcommission not between", value1, value2, "headcommission");
            return (Criteria) this;
        }



        public Criteria andSaddressIsNull() {
            addCriterion("saddress is null");
            return (Criteria) this;
        }

        public Criteria andSaddressIsNotNull() {
            addCriterion("saddress is not null");
            return (Criteria) this;
        }

        public Criteria andSaddressEqualTo(String value) {
            addCriterion("saddress =", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressNotEqualTo(String value) {
            addCriterion("saddress <>", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressGreaterThan(String value) {
            addCriterion("saddress >", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressGreaterThanOrEqualTo(String value) {
            addCriterion("saddress >=", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressLessThan(String value) {
            addCriterion("saddress <", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressLessThanOrEqualTo(String value) {
            addCriterion("saddress <=", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressLike(String value) {
            addCriterion("saddress like", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressNotLike(String value) {
            addCriterion("saddress not like", value, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressIn(List<String> values) {
            addCriterion("saddress in", values, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressNotIn(List<String> values) {
            addCriterion("saddress not in", values, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressBetween(String value1, String value2) {
            addCriterion("saddress between", value1, value2, "saddress");
            return (Criteria) this;
        }

        public Criteria andSaddressNotBetween(String value1, String value2) {
            addCriterion("saddress not between", value1, value2, "saddress");
            return (Criteria) this;
        }

        public Criteria andTservicepriceIsNull() {
            addCriterion("tserviceprice is null");
            return (Criteria) this;
        }

        public Criteria andTservicepriceIsNotNull() {
            addCriterion("tserviceprice is not null");
            return (Criteria) this;
        }

        public Criteria andTservicepriceEqualTo(BigDecimal value) {
            addCriterion("tserviceprice =", value, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceNotEqualTo(BigDecimal value) {
            addCriterion("tserviceprice <>", value, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceGreaterThan(BigDecimal value) {
            addCriterion("tserviceprice >", value, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("tserviceprice >=", value, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceLessThan(BigDecimal value) {
            addCriterion("tserviceprice <", value, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("tserviceprice <=", value, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceIn(List<BigDecimal> values) {
            addCriterion("tserviceprice in", values, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceNotIn(List<BigDecimal> values) {
            addCriterion("tserviceprice not in", values, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tserviceprice between", value1, value2, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTservicepriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("tserviceprice not between", value1, value2, "tserviceprice");
            return (Criteria) this;
        }

        public Criteria andTXiaoquIsNull() {
            addCriterion("t_xiaoqu is null");
            return (Criteria) this;
        }

        public Criteria andTXiaoquIsNotNull() {
            addCriterion("t_xiaoqu is not null");
            return (Criteria) this;
        }

        public Criteria andTXiaoquEqualTo(String value) {
            addCriterion("t_xiaoqu =", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquNotEqualTo(String value) {
            addCriterion("t_xiaoqu <>", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquGreaterThan(String value) {
            addCriterion("t_xiaoqu >", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquGreaterThanOrEqualTo(String value) {
            addCriterion("t_xiaoqu >=", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquLessThan(String value) {
            addCriterion("t_xiaoqu <", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquLessThanOrEqualTo(String value) {
            addCriterion("t_xiaoqu <=", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquLike(String value) {
            addCriterion("t_xiaoqu like", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquNotLike(String value) {
            addCriterion("t_xiaoqu not like", value, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquIn(List<String> values) {
            addCriterion("t_xiaoqu in", values, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquNotIn(List<String> values) {
            addCriterion("t_xiaoqu not in", values, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquBetween(String value1, String value2) {
            addCriterion("t_xiaoqu between", value1, value2, "tXiaoqu");
            return (Criteria) this;
        }

        public Criteria andTXiaoquNotBetween(String value1, String value2) {
            addCriterion("t_xiaoqu not between", value1, value2, "tXiaoqu");
            return (Criteria) this;
        }


        public Criteria andIsIntegralIsNull() {
            addCriterion("is_integral is null");
            return (Criteria) this;
        }

        public Criteria andIsIntegralIsNotNull() {
            addCriterion("is_integral is not null");
            return (Criteria) this;
        }


        public Criteria andGoodstotalIsNull() {
            addCriterion("goodstotal is null");
            return (Criteria) this;
        }

        public Criteria andGoodstotalIsNotNull() {
            addCriterion("goodstotal is not null");
            return (Criteria) this;
        }

        public Criteria andGoodstotalEqualTo(Integer value) {
            addCriterion("goodstotal =", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalNotEqualTo(Integer value) {
            addCriterion("goodstotal <>", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalGreaterThan(Integer value) {
            addCriterion("goodstotal >", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalGreaterThanOrEqualTo(Integer value) {
            addCriterion("goodstotal >=", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalLessThan(Integer value) {
            addCriterion("goodstotal <", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalLessThanOrEqualTo(Integer value) {
            addCriterion("goodstotal <=", value, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalIn(List<Integer> values) {
            addCriterion("goodstotal in", values, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalNotIn(List<Integer> values) {
            addCriterion("goodstotal not in", values, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalBetween(Integer value1, Integer value2) {
            addCriterion("goodstotal between", value1, value2, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andGoodstotalNotBetween(Integer value1, Integer value2) {
            addCriterion("goodstotal not between", value1, value2, "goodstotal");
            return (Criteria) this;
        }

        public Criteria andCentreIdIsNull() {
            addCriterion("centre_id is null");
            return (Criteria) this;
        }

        public Criteria andCentreIdIsNotNull() {
            addCriterion("centre_id is not null");
            return (Criteria) this;
        }

        public Criteria andCentreIdEqualTo(Long value) {
            addCriterion("centre_id =", value, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdNotEqualTo(Long value) {
            addCriterion("centre_id <>", value, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdGreaterThan(Long value) {
            addCriterion("centre_id >", value, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdGreaterThanOrEqualTo(Long value) {
            addCriterion("centre_id >=", value, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdLessThan(Long value) {
            addCriterion("centre_id <", value, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdLessThanOrEqualTo(Long value) {
            addCriterion("centre_id <=", value, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdIn(List<Long> values) {
            addCriterion("centre_id in", values, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdNotIn(List<Long> values) {
            addCriterion("centre_id not in", values, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdBetween(Long value1, Long value2) {
            addCriterion("centre_id between", value1, value2, "centreId");
            return (Criteria) this;
        }

        public Criteria andCentreIdNotBetween(Long value1, Long value2) {
            addCriterion("centre_id not between", value1, value2, "centreId");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}